Pandas Profiling Report

Dataset statistics

Number of variables	21
Number of observations	1000
Missing cells	171
Missing cells (%)	0.8%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	396.7 KiB
Average record size in memory	406.2 B

Variable types

NUM	12
BOOL	4
CAT	4
DATE	1

Reproduction

Analysis started	2020-08-20 12:56:35.177499
Analysis finished	2020-08-20 12:57:05.488512
Duration	30.31 seconds
Version	pandas-profiling v2.7.1
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

`Store` is highly correlated with `df_index`	High correlation
`df_index` is highly correlated with `Store`	High correlation
`Customers` is highly correlated with `Sales`	High correlation
`Sales` is highly correlated with `Customers`	High correlation
`sales_per_customer` has 171 (17.1%) missing values	Missing
`df_index` has unique values	Unique
`Sales` has 171 (17.1%) zeros	Zeros
`Customers` has 171 (17.1%) zeros	Zeros

df_index
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct count	1000
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	503563.579
Minimum	827
Maximum	1015129
Zeros	0
Zeros (%)	0.0%
Memory size	7.9 KiB

Quantile statistics

Minimum	827
5-th percentile	59821.25
Q1	260922.75
median	488470
Q3	752031
95-th percentile	960340.75
Maximum	1015129
Range	1014302
Interquartile range (IQR)	491108.25

Descriptive statistics

Standard deviation	285526.0505
Coefficient of variation (CV)	0.5670109245
Kurtosis	-1.155248824
Mean	503563.579
Median Absolute Deviation (MAD)	241878
Skewness	0.05046897516
Sum	503563579
Variance	8.152512549e+10

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
485374	1	0.1%
920241	1	0.1%
740100	1	0.1%
152261	1	0.1%
572100	1	0.1%
1002503	1	0.1%
431700	1	0.1%
246462	1	0.1%
469692	1	0.1%
919525	1	0.1%
Other values (990)	990	99.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
827	1	0.1%
1441	1	0.1%
1519	1	0.1%
2117	1	0.1%
3649	1	0.1%

Value	Count	Frequency (%)
1015129	1	0.1%
1013951	1	0.1%
1012717	1	0.1%
1011016	1	0.1%
1010994	1	0.1%

Store
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	665
Unique (%)	66.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	552.904
Minimum	1
Maximum	1113
Zeros	0
Zeros (%)	0.0%
Memory size	7.9 KiB

Quantile statistics

Minimum	1
5-th percentile	65.95
Q1	288
median	536
Q3	826.25
95-th percentile	1053.1
Maximum	1113
Range	1112
Interquartile range (IQR)	538.25

Descriptive statistics

Standard deviation	312.9912816
Coefficient of variation (CV)	0.5660861226
Kurtosis	-1.15569261
Mean	552.904
Median Absolute Deviation (MAD)	264.5
Skewness	0.04978727165
Sum	552904
Variance	97963.54233

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
281	5	0.5%
211	4	0.4%
678	4	0.4%
880	4	0.4%
291	4	0.4%
271	4	0.4%
268	4	0.4%
943	4	0.4%
441	4	0.4%
527	4	0.4%
Other values (655)	959	95.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	0.1%
2	2	0.2%
3	1	0.1%
4	1	0.1%
6	1	0.1%

Value	Count	Frequency (%)
1113	1	0.1%
1112	1	0.1%
1111	1	0.1%
1109	2	0.2%
1107	2	0.2%

DayOfWeek
Real number (ℝ_≥0)

Distinct count	7
Unique (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.991
Minimum	1
Maximum	7
Zeros	0
Zeros (%)	0.0%
Memory size	7.9 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	7
Maximum	7
Range	6
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	1.969466374
Coefficient of variation (CV)	0.4934769165
Kurtosis	-1.186803223
Mean	3.991
Median Absolute Deviation (MAD)	2
Skewness	0.0401277736
Sum	3991
Variance	3.878797798

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
4	160	16.0%
3	157	15.7%
7	146	14.6%
2	139	13.9%
5	138	13.8%
1	134	13.4%
6	126	12.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	134	13.4%
2	139	13.9%
3	157	15.7%
4	160	16.0%
5	138	13.8%

Value	Count	Frequency (%)
7	146	14.6%
6	126	12.6%
5	138	13.8%
4	160	16.0%
3	157	15.7%

Date
Date

Distinct count	615
Unique (%)	61.5%
Missing	0
Missing (%)	0.0%
Memory size	7.9 KiB

Minimum	2013-01-01 00:00:00
Maximum	2015-07-31 00:00:00

Histogram

Histogram

Sales
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct count	790
Unique (%)	79.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5651.73
Minimum	0
Maximum	16331
Zeros	171
Zeros (%)	17.1%
Memory size	7.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	3882.75
median	5745.5
Q3	7848.5
95-th percentile	11562.75
Maximum	16331
Range	16331
Interquartile range (IQR)	3965.75

Descriptive statistics

Standard deviation	3515.341922
Coefficient of variation (CV)	0.6219939598
Kurtosis	-0.2589751912
Mean	5651.73
Median Absolute Deviation (MAD)	1969.5
Skewness	0.05063180166
Sum	5651730
Variance	12357628.83

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	171	17.1%
7135	3	0.3%
5432	3	0.3%
8383	3	0.3%
3863	3	0.3%
7303	2	0.2%
9565	2	0.2%
6020	2	0.2%
5703	2	0.2%
5178	2	0.2%
Other values (780)	807	80.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	171	17.1%
1032	1	0.1%
1685	1	0.1%
1736	1	0.1%
1847	1	0.1%

Value	Count	Frequency (%)
16331	1	0.1%
15537	1	0.1%
15535	1	0.1%
15171	1	0.1%
15077	1	0.1%

Customers
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct count	542
Unique (%)	54.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	605.101
Minimum	0
Maximum	1868
Zeros	171
Zeros (%)	17.1%
Memory size	7.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	409.5
median	622.5
Q3	817
95-th percentile	1292.1
Maximum	1868
Range	1868
Interquartile range (IQR)	407.5

Descriptive statistics

Standard deviation	383.820561
Coefficient of variation (CV)	0.6343082576
Kurtosis	0.1920091675
Mean	605.101
Median Absolute Deviation (MAD)	204.5
Skewness	0.2422526649
Sum	605101
Variance	147318.223

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	171	17.1%
523	6	0.6%
635	6	0.6%
491	5	0.5%
641	5	0.5%
501	5	0.5%
700	5	0.5%
643	4	0.4%
668	4	0.4%
717	4	0.4%
Other values (532)	785	78.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	171	17.1%
176	1	0.1%
182	1	0.1%
209	1	0.1%
210	1	0.1%

Value	Count	Frequency (%)
1868	1	0.1%
1842	1	0.1%
1841	1	0.1%
1814	1	0.1%
1795	1	0.1%

Open
Boolean

Distinct count	2
Unique (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	7.9 KiB

1	829
0	171

Frequency Table

Value	Count	Frequency (%)
1	829	82.9%
0	171	17.1%

Promo
Boolean

Distinct count	2
Unique (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	7.9 KiB

0	609
1	391

Frequency Table

Value	Count	Frequency (%)
0	609	60.9%
1	391	39.1%

StateHoliday
Categorical

Distinct count	4
Unique (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	7.9 KiB

o	973
a	19
c	6
b	2

Value	Count	Frequency (%)
o	973	97.3%
a	19	1.9%
c	6	0.6%
b	2	0.2%

Length

Max length	1
Mean length	1
Min length	1

Value	Count	Frequency (%)
Lowercase_Letter	4	100.0%

Value	Count	Frequency (%)
Latin	4	100.0%

Value	Count	Frequency (%)
ASCII	4	100.0%

SchoolHoliday
Boolean

Distinct count	2
Unique (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	7.9 KiB

0	822
1	178

Frequency Table

Value	Count	Frequency (%)
0	822	82.2%
1	178	17.8%

StoreType
Categorical

Distinct count	4
Unique (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	7.9 KiB

a	546
d	326
c	117
b	11

Value	Count	Frequency (%)
a	546	54.6%
d	326	32.6%
c	117	11.7%
b	11	1.1%

Length

Max length	1
Mean length	1
Min length	1

Value	Count	Frequency (%)
Lowercase_Letter	4	100.0%

Value	Count	Frequency (%)
Latin	4	100.0%

Value	Count	Frequency (%)
ASCII	4	100.0%

Assortment
Categorical

Distinct count	3
Unique (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	7.9 KiB

a	514
c	479
b	7

Value	Count	Frequency (%)
a	514	51.4%
c	479	47.9%
b	7	0.7%

Length

Max length	1
Mean length	1
Min length	1

Value	Count	Frequency (%)
Lowercase_Letter	3	100.0%

Value	Count	Frequency (%)
Latin	3	100.0%

Value	Count	Frequency (%)
ASCII	3	100.0%

CompetitionDistance
Real number (ℝ_≥0)

Distinct count	461
Unique (%)	46.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4927.62
Minimum	30.0
Maximum	27650.0
Zeros	0
Zeros (%)	0.0%
Memory size	7.9 KiB

Quantile statistics

Minimum	30
5-th percentile	139.5
Q1	760
median	2470
Q3	6892.5
95-th percentile	18540
Maximum	27650
Range	27620
Interquartile range (IQR)	6132.5

Descriptive statistics

Standard deviation	5813.044561
Coefficient of variation (CV)	1.179686048
Kurtosis	1.830858064
Mean	4927.62
Median Absolute Deviation (MAD)	2060
Skewness	1.596393661
Sum	4927620
Variance	33791487.07

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
250	11	1.1%
350	8	0.8%
2710	8	0.8%
50	7	0.7%
550	7	0.7%
230	7	0.7%
1070	7	0.7%
2190	7	0.7%
1080	7	0.7%
190	7	0.7%
Other values (451)	924	92.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
30	5	0.5%
40	5	0.5%
50	7	0.7%
60	3	0.3%
70	4	0.4%

Value	Count	Frequency (%)
27650	1	0.1%
27530	2	0.2%
27150	1	0.1%
26490	1	0.1%
26130	1	0.1%

CompetitionOpenSinceMonth
Real number (ℝ_≥0)

Distinct count	12
Unique (%)	1.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	7.827
Minimum	1.0
Maximum	12.0
Zeros	0
Zeros (%)	0.0%
Memory size	7.9 KiB

Quantile statistics

Minimum	1
5-th percentile	2.95
Q1	6
median	9
Q3	9
95-th percentile	11
Maximum	12
Range	11
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.691154643
Coefficient of variation (CV)	0.3438296465
Kurtosis	-0.2322506994
Mean	7.827
Median Absolute Deviation (MAD)	1
Skewness	-0.8127326447
Sum	7827
Variance	7.242313313

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
9	465	46.5%
4	79	7.9%
11	77	7.7%
7	64	6.4%
10	51	5.1%
3	50	5.0%
12	48	4.8%
6	46	4.6%
5	42	4.2%
2	35	3.5%
Other values (2)	43	4.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	15	1.5%
2	35	3.5%
3	50	5.0%
4	79	7.9%
5	42	4.2%

Value	Count	Frequency (%)
12	48	4.8%
11	77	7.7%
10	51	5.1%
9	465	46.5%
8	28	2.8%

CompetitionOpenSinceYear
Real number (ℝ_≥0)

Distinct count	20
Unique (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2009.496
Minimum	1900.0
Maximum	2015.0
Zeros	0
Zeros (%)	0.0%
Memory size	7.9 KiB

Quantile statistics

Minimum	1900
5-th percentile	2002
Q1	2008
median	2011
Q3	2011
95-th percentile	2014
Maximum	2015
Range	115
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	5.378746593
Coefficient of variation (CV)	0.002676664494
Kurtosis	184.3885348
Mean	2009.496
Median Absolute Deviation (MAD)	1
Skewness	-10.28430612
Sum	2009496
Variance	28.93091491

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2011	398	39.8%
2014	70	7.0%
2012	64	6.4%
2013	57	5.7%
2007	56	5.6%
2005	56	5.6%
2010	54	5.4%
2009	52	5.2%
2006	45	4.5%
2008	36	3.6%
Other values (10)	112	11.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1900	1	0.1%
1961	2	0.2%
1990	4	0.4%
1999	2	0.2%
2000	7	0.7%

Value	Count	Frequency (%)
2015	30	3.0%
2014	70	7.0%
2013	57	5.7%
2012	64	6.4%
2011	398	39.8%

Promo2
Boolean

Distinct count	2
Unique (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	7.9 KiB

1	518
0	482

Frequency Table

Value	Count	Frequency (%)
1	518	51.8%
0	482	48.2%

Promo2SinceWeek
Real number (ℝ_≥0)

Distinct count	21
Unique (%)	2.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	18.415
Minimum	1.0
Maximum	50.0
Zeros	0
Zeros (%)	0.0%
Memory size	7.9 KiB

Quantile statistics

Minimum	1
5-th percentile	5
Q1	14
median	14
Q3	18
95-th percentile	40
Maximum	50
Range	49
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	10.99143242
Coefficient of variation (CV)	0.5968738755
Kurtosis	0.4139670615
Mean	18.415
Median Absolute Deviation (MAD)	0
Skewness	1.176794421
Sum	18415
Variance	120.8115866

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
14	562	56.2%
40	55	5.5%
10	38	3.8%
5	36	3.6%
37	36	3.6%
1	35	3.5%
18	32	3.2%
31	31	3.1%
22	31	3.1%
13	29	2.9%
Other values (11)	115	11.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	35	3.5%
5	36	3.6%
6	1	0.1%
9	20	2.0%
10	38	3.8%

Value	Count	Frequency (%)
50	1	0.1%
48	11	1.1%
45	24	2.4%
44	5	0.5%
40	55	5.5%

Promo2SinceYear
Real number (ℝ_≥0)

Distinct count	7
Unique (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2011.355
Minimum	2009.0
Maximum	2015.0
Zeros	0
Zeros (%)	0.0%
Memory size	7.9 KiB

Quantile statistics

Minimum	2009
5-th percentile	2009
Q1	2011
median	2011
Q3	2012
95-th percentile	2014
Maximum	2015
Range	6
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.215916713
Coefficient of variation (CV)	0.0006045261593
Kurtosis	0.8004152121
Mean	2011.355
Median Absolute Deviation (MAD)	0
Skewness	0.7550592501
Sum	2011355
Variance	1.478453453

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2011	622	62.2%
2013	103	10.3%
2012	73	7.3%
2014	71	7.1%
2009	61	6.1%
2010	59	5.9%
2015	11	1.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2009	61	6.1%
2010	59	5.9%
2011	622	62.2%
2012	73	7.3%
2013	103	10.3%

Value	Count	Frequency (%)
2015	11	1.1%
2014	71	7.1%
2013	103	10.3%
2012	73	7.3%
2011	622	62.2%

PromoInterval
Categorical

Distinct count	3
Unique (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	7.9 KiB

Jan,Apr,Jul,Oct	777
Feb,May,Aug,Nov	123
Mar,Jun,Sept,Dec	100

Value	Count	Frequency (%)
Jan,Apr,Jul,Oct	777	77.7%
Feb,May,Aug,Nov	123	12.3%
Mar,Jun,Sept,Dec	100	10.0%

Length

Max length	16
Mean length	15.1
Min length	15

Value	Count	Frequency (%)
Lowercase_Letter	14	60.9%
Uppercase_Letter	8	34.8%
Other_Punctuation	1	4.3%

Value	Count	Frequency (%)
Latin	22	95.7%
Common	1	4.3%

Value	Count	Frequency (%)
ASCII	23	100.0%

month
Real number (ℝ_≥0)

Distinct count	12
Unique (%)	1.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5.821
Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Memory size	7.9 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	6
Q3	8
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	3.408897121
Coefficient of variation (CV)	0.5856205327
Kurtosis	-1.042538365
Mean	5.821
Median Absolute Deviation (MAD)	3
Skewness	0.2833487739
Sum	5821
Variance	11.62057958

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	112	11.2%
2	105	10.5%
7	103	10.3%
6	100	10.0%
5	93	9.3%
3	92	9.2%
4	91	9.1%
12	72	7.2%
8	62	6.2%
11	61	6.1%
Other values (2)	109	10.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	112	11.2%
2	105	10.5%
3	92	9.2%
4	91	9.1%
5	93	9.3%

Value	Count	Frequency (%)
12	72	7.2%
11	61	6.1%
10	61	6.1%
9	48	4.8%
8	62	6.2%

sales_per_customer
Real number (ℝ_≥0)

MISSING

Distinct count	829
Unique (%)	100.0%
Missing	171
Missing (%)	17.1%
Infinite	0
Infinite (%)	0.0%

Mean	9.601078294965776
Minimum	3.6750871080139373
Maximum	17.48175182481752
Zeros	0
Zeros (%)	0.0%
Memory size	7.9 KiB

Quantile statistics

Minimum	3.675087108
5-th percentile	6.532093883
Q1	7.982791587
median	9.411067194
Q3	10.95709571
95-th percentile	13.74064806
Maximum	17.48175182
Range	13.80666472
Interquartile range (IQR)	2.974304123

Descriptive statistics

Standard deviation	2.218568376
Coefficient of variation (CV)	0.2310749176
Kurtosis	0.1609142098
Mean	9.601078295
Median Absolute Deviation (MAD)	1.463609567
Skewness	0.5190732953
Sum	7959.293907
Variance	4.922045639

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
11.39563438	1	0.1%
7.984168865	1	0.1%
10.88076312	1	0.1%
6.773491592	1	0.1%
10.56507937	1	0.1%
9.438998957	1	0.1%
8.317200298	1	0.1%
9.532544379	1	0.1%
11.65037594	1	0.1%
7.7	1	0.1%
Other values (819)	819	81.9%
(Missing)	171	17.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3.675087108	1	0.1%
4.028846154	1	0.1%
4.11010453	1	0.1%
4.37366167	1	0.1%
4.780044101	1	0.1%

Value	Count	Frequency (%)
17.48175182	1	0.1%
17.26457399	1	0.1%
16.81946625	1	0.1%
16.39049236	1	0.1%
15.83527132	1	0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

First rows

	df_index	Store	DayOfWeek	Date	Sales	Customers	Open	Promo	StateHoliday	SchoolHoliday	StoreType	Assortment	CompetitionDistance	CompetitionOpenSinceMonth	CompetitionOpenSinceYear	Promo2	Promo2SinceWeek	Promo2SinceYear	PromoInterval	month	sales_per_customer
0	1010994	1109	6	2015-01-17	3328	315	1	0	o	0	c	a	3490.0	4.0	2011.0	1	22.0	2012.0	Jan,Apr,Jul,Oct	1	10.565079
1	433317	475	7	2014-06-01	0	0	0	0	o	0	a	a	140.0	9.0	2005.0	0	14.0	2011.0	Jan,Apr,Jul,Oct	6	NaN
2	281004	310	6	2014-12-13	9739	809	1	0	o	0	a	c	2290.0	9.0	2011.0	1	10.0	2014.0	Mar,Jun,Sept,Dec	12	12.038319
3	316424	348	3	2013-12-18	12225	906	1	1	o	0	a	a	16490.0	9.0	2011.0	1	22.0	2012.0	Jan,Apr,Jul,Oct	12	13.493377
4	315963	347	7	2013-02-24	0	0	0	0	o	0	d	c	9360.0	7.0	2013.0	1	22.0	2012.0	Mar,Jun,Sept,Dec	2	NaN
5	277645	306	3	2013-10-30	4151	464	1	0	o	1	a	a	5100.0	4.0	2007.0	1	40.0	2014.0	Jan,Apr,Jul,Oct	10	8.946121
6	544903	598	3	2015-07-22	4886	673	1	0	o	0	c	a	550.0	12.0	2013.0	1	40.0	2014.0	Jan,Apr,Jul,Oct	7	7.260030
7	251179	277	7	2015-07-12	0	0	0	0	o	0	d	c	7840.0	9.0	2011.0	1	31.0	2009.0	Feb,May,Aug,Nov	7	NaN
8	966281	1060	5	2015-02-13	7433	855	1	0	o	0	a	c	3430.0	9.0	2011.0	1	31.0	2013.0	Feb,May,Aug,Nov	2	8.693567
9	655250	720	7	2013-06-23	0	0	0	0	o	0	a	c	15320.0	3.0	2011.0	1	14.0	2013.0	Feb,May,Aug,Nov	6	NaN

Last rows

	df_index	Store	DayOfWeek	Date	Sales	Customers	Open	Promo	StateHoliday	SchoolHoliday	StoreType	Assortment	CompetitionDistance	CompetitionOpenSinceMonth	CompetitionOpenSinceYear	Promo2	Promo2SinceWeek	Promo2SinceYear	PromoInterval	month	sales_per_customer
990	292769	322	5	2013-03-08	5862	597	1	1	o	0	a	a	17500.0	4.0	2001.0	1	37.0	2009.0	Jan,Apr,Jul,Oct	3	9.819095
991	633191	695	2	2013-06-04	6534	644	1	1	o	0	a	a	550.0	7.0	2011.0	1	1.0	2012.0	Jan,Apr,Jul,Oct	6	10.145963
992	688715	757	2	2015-04-07	6920	654	1	0	o	1	a	c	3450.0	9.0	2011.0	0	14.0	2011.0	Jan,Apr,Jul,Oct	4	10.581040
993	517459	568	7	2015-05-03	0	0	0	0	o	0	d	c	4270.0	9.0	2011.0	1	1.0	2013.0	Jan,Apr,Jul,Oct	5	NaN
994	463499	508	1	2013-05-13	7905	721	1	1	o	0	a	c	1280.0	9.0	2011.0	1	40.0	2011.0	Jan,Apr,Jul,Oct	5	10.963939
995	702008	771	5	2013-12-20	10197	1043	1	1	o	0	a	a	20640.0	9.0	2007.0	0	14.0	2011.0	Jan,Apr,Jul,Oct	12	9.776606
996	623582	685	4	2014-06-12	5592	570	1	0	o	0	a	a	650.0	11.0	2013.0	1	37.0	2009.0	Jan,Apr,Jul,Oct	6	9.810526
997	826738	908	3	2015-03-25	3080	307	1	0	o	0	a	a	1980.0	7.0	2010.0	1	37.0	2009.0	Jan,Apr,Jul,Oct	3	10.032573
998	411915	452	6	2014-09-13	3045	292	1	0	o	0	a	c	1850.0	8.0	2013.0	1	5.0	2011.0	Feb,May,Aug,Nov	9	10.428082
999	72328	80	6	2015-04-04	10578	844	1	0	o	0	d	a	7910.0	9.0	2011.0	0	14.0	2011.0	Jan,Apr,Jul,Oct	4	12.533175

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows